﻿CREATE TABLE [dbo].[CLM_837I_2300_OccurenceInformation]
(
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[HI_HI01_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI01_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI02_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI02_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI03_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI03_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI04_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI04_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI05_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI05_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI06_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI06_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI07_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI07_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI08_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI08_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI09_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI09_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI010_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI010_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI011_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI011_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI012_2_OccurrenceCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HI_HI012_4_OccurrenceCodeDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_HL01_SubscriberHierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_HL01_PatientHierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSMessageId] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSInterchangeId] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


